Re: MySQL Queries -(sub question - time field)

I'm working on changing the structure of my tables a bit, and had a
question pop to mind that I'd wondered before but haven't figured out yet.
If I have a bunch of pieces of data that are structured like "53:04",
"2:34", etc.... how can I have an extra xx: added to the front of them so
that the minutes and seconds are in the right spot?  (IOW, 2:34 ->
00:02:34) There's a way to do this when putting the data into the time
field, isn't there?

~ Nathan Lyle

Email: natelyle(at)chartermi.net
Phone: (906)485-4806
http://www.nathanlyle.com

"Those that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety." - Ben Franklin

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA